Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | |
FinancialLedgerAccountID (FK) | The reference for the FinancialLedgeraAccount | ID_ACNT_LDG | Identity | integer | FinancialLedgerAccount(CO_LE_ACNT_FN) |
ServiceTermsCode (FK) | A retailer assigned uniquecide for the set of terms and conditions governing the sale or rental of the ServiceItem | LU_TRM_SV | Code2 | char(2) | ServiceTermsAndConditions(CO_TRMCD_SV) |
TypeCode | A code to denote the type of SERVICE ITEM. | TY_ITM_SV | Code2 | char(2) | |
BaseCostAmount | The base cost amount of the SERVICE ITEM. This cost excludes all promotional allowances. | CP_BS_SV_ITM | Money | decimal(16,5) | |
NetCostAmount | The net cost price of the SERVCE ITEM. this cost includes all promotional allowances. | CP_NT_SV_ITM | Money | decimal(16,5) | |
CostsEstablishedDate | The effective date of the current cost price for the SERVICE ITEM. | DC_CST_EST_SV_ITM | DateCalendar | date | |